Dataset statistics
| Number of variables | 14 |
|---|---|
| Number of observations | 337096 |
| Missing cells | 54659 |
| Missing cells (%) | 1.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 36.0 MiB |
| Average record size in memory | 112.0 B |
Variable types
| Categorical | 3 |
|---|---|
| DateTime | 1 |
| Numeric | 9 |
| Text | 1 |
VERSIE has constant value "" | Constant |
DATUM_BESTAND has constant value "" | Constant |
PEILDATUM has constant value "" | Constant |
BEHANDELEND_SPECIALISME_CD is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
AANTAL_PAT_PER_ZPD is highly overall correlated with AANTAL_SUBTRAJECT_PER_ZPD | High correlation |
AANTAL_SUBTRAJECT_PER_ZPD is highly overall correlated with AANTAL_PAT_PER_ZPD | High correlation |
AANTAL_PAT_PER_DIAG is highly overall correlated with AANTAL_SUBTRAJECT_PER_DIAG | High correlation |
AANTAL_SUBTRAJECT_PER_DIAG is highly overall correlated with AANTAL_PAT_PER_DIAG | High correlation |
AANTAL_PAT_PER_SPC is highly overall correlated with BEHANDELEND_SPECIALISME_CD and 1 other fields | High correlation |
AANTAL_SUBTRAJECT_PER_SPC is highly overall correlated with AANTAL_PAT_PER_SPC | High correlation |
GEMIDDELDE_VERKOOPPRIJS has 54659 (16.2%) missing values | Missing |
AANTAL_SUBTRAJECT_PER_ZPD is highly skewed (γ1 = 21.31860066) | Skewed |
Reproduction
| Analysis started | 2023-07-19 18:00:31.435338 |
|---|---|
| Analysis finished | 2023-07-19 18:00:50.923706 |
| Duration | 19.49 seconds |
| Software version | ydata-profiling v0.0.dev0 |
| Download configuration | config.json |
VERSIE
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 1.0 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1011288 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1.0 |
|---|---|
| 2nd row | 1.0 |
| 3rd row | 1.0 |
| 4th row | 1.0 |
| 5th row | 1.0 |
Common Values
| Value | Count | Frequency (%) |
| 1.0 | 337096 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1.0 | 337096 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 337096 | |
| . | 337096 | |
| 0 | 337096 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 674192 | |
| Other Punctuation | 337096 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 337096 | |
| 0 | 337096 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 337096 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1011288 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 337096 | |
| . | 337096 | |
| 0 | 337096 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1011288 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 337096 | |
| . | 337096 | |
| 0 | 337096 |
DATUM_BESTAND
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 2023-07-07 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3370960 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2023-07-07 |
|---|---|
| 2nd row | 2023-07-07 |
| 3rd row | 2023-07-07 |
| 4th row | 2023-07-07 |
| 5th row | 2023-07-07 |
Common Values
| Value | Count | Frequency (%) |
| 2023-07-07 | 337096 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2023-07-07 | 337096 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| - | 674192 | |
| 7 | 674192 | |
| 3 | 337096 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2696768 | |
| Dash Punctuation | 674192 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| 7 | 674192 | |
| 3 | 337096 | 12.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 674192 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3370960 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| - | 674192 | |
| 7 | 674192 | |
| 3 | 337096 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3370960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| - | 674192 | |
| 7 | 674192 | |
| 3 | 337096 | 10.0% |
PEILDATUM
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| 2023-07-01 |
|---|
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 3370960 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2023-07-01 |
|---|---|
| 2nd row | 2023-07-01 |
| 3rd row | 2023-07-01 |
| 4th row | 2023-07-01 |
| 5th row | 2023-07-01 |
Common Values
| Value | Count | Frequency (%) |
| 2023-07-01 | 337096 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 2023-07-01 | 337096 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| - | 674192 | |
| 3 | 337096 | 10.0% |
| 7 | 337096 | 10.0% |
| 1 | 337096 | 10.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2696768 | |
| Dash Punctuation | 674192 | 20.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| 3 | 337096 | 12.5% |
| 7 | 337096 | 12.5% |
| 1 | 337096 | 12.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 674192 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 3370960 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| - | 674192 | |
| 3 | 337096 | 10.0% |
| 7 | 337096 | 10.0% |
| 1 | 337096 | 10.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3370960 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 1011288 | |
| 2 | 674192 | |
| - | 674192 | |
| 3 | 337096 | 10.0% |
| 7 | 337096 | 10.0% |
| 1 | 337096 | 10.0% |
JAAR
Date
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Minimum | 2012-01-01 00:00:00 |
|---|---|
| Maximum | 2023-01-01 00:00:00 |
Histogram with fixed size bins (bins=12)
BEHANDELEND_SPECIALISME_CD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 28 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 447.49793 |
| Minimum | 301 |
|---|---|
| Maximum | 8418 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 301 |
|---|---|
| 5-th percentile | 302 |
| Q1 | 305 |
| median | 313 |
| Q3 | 322 |
| 95-th percentile | 361 |
| Maximum | 8418 |
| Range | 8117 |
| Interquartile range (IQR) | 17 |
Descriptive statistics
| Standard deviation | 1025.4821 |
|---|---|
| Coefficient of variation (CV) | 2.2915906 |
| Kurtosis | 56.322438 |
| Mean | 447.49793 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | 7.6319158 |
| Sum | 1.5084976 × 108 |
| Variance | 1051613.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=28)
| Value | Count | Frequency (%) |
| 305 | 47282 | |
| 313 | 43837 | |
| 303 | 38807 | |
| 330 | 26683 | 7.9% |
| 316 | 22847 | 6.8% |
| 308 | 17998 | 5.3% |
| 306 | 14149 | 4.2% |
| 324 | 13803 | 4.1% |
| 301 | 13551 | 4.0% |
| 304 | 10997 | 3.3% |
| Other values (18) | 87142 |
| Value | Count | Frequency (%) |
| 301 | 13551 | 4.0% |
| 302 | 7443 | 2.2% |
| 303 | 38807 | |
| 304 | 10997 | 3.3% |
| 305 | 47282 | |
| 306 | 14149 | 4.2% |
| 307 | 5946 | 1.8% |
| 308 | 17998 | 5.3% |
| 310 | 3715 | 1.1% |
| 313 | 43837 |
| Value | Count | Frequency (%) |
| 8418 | 4614 | 1.4% |
| 8416 | 866 | 0.3% |
| 1900 | 223 | 0.1% |
| 390 | 945 | 0.3% |
| 389 | 3558 | 1.1% |
| 362 | 4394 | 1.3% |
| 361 | 2450 | 0.7% |
| 335 | 3425 | 1.0% |
| 330 | 26683 | |
| 329 | 888 | 0.3% |
| Distinct | 1900 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
Length
| Max length | 4 |
|---|---|
| Median length | 3 |
| Mean length | 3.35117 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1129666 |
|---|---|
| Distinct characters | 25 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 11 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 11 |
|---|---|
| 2nd row | 11 |
| 3rd row | 13 |
| 4th row | 11 |
| 5th row | 12 |
| Value | Count | Frequency (%) |
| 101 | 1445 | 0.4% |
| 402 | 1393 | 0.4% |
| 301 | 1361 | 0.4% |
| 403 | 1359 | 0.4% |
| 201 | 1281 | 0.4% |
| 203 | 1266 | 0.4% |
| 401 | 1141 | 0.3% |
| 404 | 1123 | 0.3% |
| 409 | 1096 | 0.3% |
| 302 | 1086 | 0.3% |
| Other values (1890) | 324545 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 216025 | |
| 0 | 207474 | |
| 2 | 149690 | |
| 3 | 122411 | |
| 5 | 87045 | |
| 9 | 81402 | 7.2% |
| 4 | 80155 | 7.1% |
| 7 | 66523 | 5.9% |
| 6 | 58885 | 5.2% |
| 8 | 48622 | 4.3% |
| Other values (15) | 11434 | 1.0% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 1118232 | |
| Uppercase Letter | 11434 | 1.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 2145 | |
| M | 1923 | |
| B | 1379 | |
| Z | 980 | |
| E | 965 | |
| D | 749 | 6.6% |
| A | 737 | 6.4% |
| F | 721 | 6.3% |
| K | 371 | 3.2% |
| C | 369 | 3.2% |
| Other values (5) | 1095 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 216025 | |
| 0 | 207474 | |
| 2 | 149690 | |
| 3 | 122411 | |
| 5 | 87045 | |
| 9 | 81402 | 7.3% |
| 4 | 80155 | 7.2% |
| 7 | 66523 | 5.9% |
| 6 | 58885 | 5.3% |
| 8 | 48622 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1118232 | |
| Latin | 11434 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 2145 | |
| M | 1923 | |
| B | 1379 | |
| Z | 980 | |
| E | 965 | |
| D | 749 | 6.6% |
| A | 737 | 6.4% |
| F | 721 | 6.3% |
| K | 371 | 3.2% |
| C | 369 | 3.2% |
| Other values (5) | 1095 |
Common
| Value | Count | Frequency (%) |
| 1 | 216025 | |
| 0 | 207474 | |
| 2 | 149690 | |
| 3 | 122411 | |
| 5 | 87045 | |
| 9 | 81402 | 7.3% |
| 4 | 80155 | 7.2% |
| 7 | 66523 | 5.9% |
| 6 | 58885 | 5.3% |
| 8 | 48622 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1129666 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 216025 | |
| 0 | 207474 | |
| 2 | 149690 | |
| 3 | 122411 | |
| 5 | 87045 | |
| 9 | 81402 | 7.2% |
| 4 | 80155 | 7.1% |
| 7 | 66523 | 5.9% |
| 6 | 58885 | 5.2% |
| 8 | 48622 | 4.3% |
| Other values (15) | 11434 | 1.0% |
ZORGPRODUCT_CD
Real number (ℝ)
| Distinct | 6120 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.399477 × 108 |
| Minimum | 10501002 |
|---|---|
| Maximum | 9.9841808 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 10501002 |
|---|---|
| 5-th percentile | 28999038 |
| Q1 | 99799048 |
| median | 1.4959902 × 108 |
| Q3 | 9.90004 × 108 |
| 95-th percentile | 9.9051605 × 108 |
| Maximum | 9.9841808 × 108 |
| Range | 9.8791708 × 108 |
| Interquartile range (IQR) | 8.9020495 × 108 |
Descriptive statistics
| Standard deviation | 4.2879411 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.9746479 |
| Kurtosis | -1.7333869 |
| Mean | 4.399477 × 108 |
| Median Absolute Deviation (MAD) | 1.1960002 × 108 |
| Skewness | 0.47167835 |
| Sum | 1.4830461 × 1014 |
| Variance | 1.8386439 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 990004009 | 2488 | 0.7% |
| 990004007 | 2437 | 0.7% |
| 990003004 | 2323 | 0.7% |
| 990004006 | 1932 | 0.6% |
| 990356076 | 1788 | 0.5% |
| 131999228 | 1653 | 0.5% |
| 990356073 | 1644 | 0.5% |
| 131999164 | 1628 | 0.5% |
| 990003007 | 1494 | 0.4% |
| 131999194 | 1448 | 0.4% |
| Other values (6110) | 318261 |
| Value | Count | Frequency (%) |
| 10501002 | 9 | |
| 10501003 | 12 | |
| 10501004 | 12 | |
| 10501005 | 12 | |
| 10501007 | 3 | < 0.1% |
| 10501008 | 12 | |
| 10501010 | 12 | |
| 10501011 | 3 | < 0.1% |
| 11101002 | 10 | |
| 11101003 | 12 |
| Value | Count | Frequency (%) |
| 998418081 | 165 | |
| 998418080 | 151 | |
| 998418079 | 38 | < 0.1% |
| 998418077 | 9 | < 0.1% |
| 998418076 | 9 | < 0.1% |
| 998418075 | 7 | < 0.1% |
| 998418074 | 237 | |
| 998418073 | 233 | |
| 998418072 | 9 | < 0.1% |
| 998418071 | 9 | < 0.1% |
AANTAL_PAT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10307 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 513.20126 |
| Minimum | 1 |
|---|---|
| Maximum | 165185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 13 |
| Q3 | 100 |
| 95-th percentile | 1723 |
| Maximum | 165185 |
| Range | 165184 |
| Interquartile range (IQR) | 97 |
Descriptive statistics
| Standard deviation | 3203.1046 |
|---|---|
| Coefficient of variation (CV) | 6.2414201 |
| Kurtosis | 409.34858 |
| Mean | 513.20126 |
| Median Absolute Deviation (MAD) | 12 |
| Skewness | 16.765663 |
| Sum | 1.7299809 × 108 |
| Variance | 10259879 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 56505 | 16.8% |
| 2 | 27579 | 8.2% |
| 3 | 17983 | 5.3% |
| 4 | 13101 | 3.9% |
| 5 | 10256 | 3.0% |
| 6 | 8684 | 2.6% |
| 7 | 7165 | 2.1% |
| 8 | 6113 | 1.8% |
| 9 | 5520 | 1.6% |
| 10 | 4919 | 1.5% |
| Other values (10297) | 179271 |
| Value | Count | Frequency (%) |
| 1 | 56505 | |
| 2 | 27579 | |
| 3 | 17983 | 5.3% |
| 4 | 13101 | 3.9% |
| 5 | 10256 | 3.0% |
| 6 | 8684 | 2.6% |
| 7 | 7165 | 2.1% |
| 8 | 6113 | 1.8% |
| 9 | 5520 | 1.6% |
| 10 | 4919 | 1.5% |
| Value | Count | Frequency (%) |
| 165185 | 1 | |
| 162462 | 1 | |
| 155870 | 1 | |
| 154484 | 1 | |
| 154259 | 1 | |
| 153588 | 1 | |
| 144715 | 1 | |
| 118397 | 1 | |
| 115938 | 1 | |
| 113250 | 1 |
AANTAL_SUBTRAJECT_PER_ZPD
Real number (ℝ)
HIGH CORRELATION SKEWED
| Distinct | 11098 |
|---|---|
| Distinct (%) | 3.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 608.55576 |
| Minimum | 1 |
|---|---|
| Maximum | 240002 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 3 |
| median | 14 |
| Q3 | 109 |
| 95-th percentile | 1970 |
| Maximum | 240002 |
| Range | 240001 |
| Interquartile range (IQR) | 106 |
Descriptive statistics
| Standard deviation | 4132.0186 |
|---|---|
| Coefficient of variation (CV) | 6.7898768 |
| Kurtosis | 719.67091 |
| Mean | 608.55576 |
| Median Absolute Deviation (MAD) | 13 |
| Skewness | 21.318601 |
| Sum | 2.0514171 × 108 |
| Variance | 17073578 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1 | 54434 | 16.1% |
| 2 | 27098 | 8.0% |
| 3 | 17817 | 5.3% |
| 4 | 12905 | 3.8% |
| 5 | 10168 | 3.0% |
| 6 | 8632 | 2.6% |
| 7 | 7132 | 2.1% |
| 8 | 6049 | 1.8% |
| 9 | 5426 | 1.6% |
| 10 | 4960 | 1.5% |
| Other values (11088) | 182475 |
| Value | Count | Frequency (%) |
| 1 | 54434 | |
| 2 | 27098 | |
| 3 | 17817 | 5.3% |
| 4 | 12905 | 3.8% |
| 5 | 10168 | 3.0% |
| 6 | 8632 | 2.6% |
| 7 | 7132 | 2.1% |
| 8 | 6049 | 1.8% |
| 9 | 5426 | 1.6% |
| 10 | 4960 | 1.5% |
| Value | Count | Frequency (%) |
| 240002 | 1 | |
| 232423 | 1 | |
| 231954 | 1 | |
| 230966 | 1 | |
| 227936 | 1 | |
| 227409 | 1 | |
| 226304 | 1 | |
| 223891 | 1 | |
| 218673 | 1 | |
| 215133 | 1 |
AANTAL_PAT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 9186 |
|---|---|
| Distinct (%) | 2.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7695.9706 |
| Minimum | 1 |
|---|---|
| Maximum | 230642 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 35 |
| Q1 | 372 |
| median | 1664 |
| Q3 | 6235 |
| 95-th percentile | 37050 |
| Maximum | 230642 |
| Range | 230641 |
| Interquartile range (IQR) | 5863 |
Descriptive statistics
| Standard deviation | 18039.18 |
|---|---|
| Coefficient of variation (CV) | 2.3439772 |
| Kurtosis | 34.342309 |
| Mean | 7695.9706 |
| Median Absolute Deviation (MAD) | 1532 |
| Skewness | 5.0782342 |
| Sum | 2.5942809 × 109 |
| Variance | 3.25412 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 21 | 592 | 0.2% |
| 9 | 588 | 0.2% |
| 8 | 583 | 0.2% |
| 2 | 582 | 0.2% |
| 12 | 570 | 0.2% |
| 3 | 560 | 0.2% |
| 17 | 557 | 0.2% |
| 25 | 551 | 0.2% |
| 19 | 549 | 0.2% |
| 7 | 534 | 0.2% |
| Other values (9176) | 331430 |
| Value | Count | Frequency (%) |
| 1 | 506 | |
| 2 | 582 | |
| 3 | 560 | |
| 4 | 522 | |
| 5 | 528 | |
| 6 | 510 | |
| 7 | 534 | |
| 8 | 583 | |
| 9 | 588 | |
| 10 | 471 |
| Value | Count | Frequency (%) |
| 230642 | 23 | |
| 228000 | 23 | |
| 224865 | 19 | |
| 218430 | 24 | |
| 214509 | 17 | |
| 213516 | 25 | |
| 211593 | 17 | |
| 210417 | 19 | |
| 205347 | 17 | |
| 200603 | 16 |
AANTAL_SUBTRAJECT_PER_DIAG
Real number (ℝ)
HIGH CORRELATION
| Distinct | 10287 |
|---|---|
| Distinct (%) | 3.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11174.117 |
| Minimum | 1 |
|---|---|
| Maximum | 370143 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 44 |
| Q1 | 493 |
| median | 2329 |
| Q3 | 9079 |
| 95-th percentile | 52658 |
| Maximum | 370143 |
| Range | 370142 |
| Interquartile range (IQR) | 8586 |
Descriptive statistics
| Standard deviation | 27047.909 |
|---|---|
| Coefficient of variation (CV) | 2.4205857 |
| Kurtosis | 37.581068 |
| Mean | 11174.117 |
| Median Absolute Deviation (MAD) | 2160 |
| Skewness | 5.3055838 |
| Sum | 3.7667502 × 109 |
| Variance | 7.3158936 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3 | 493 | 0.1% |
| 2 | 474 | 0.1% |
| 17 | 450 | 0.1% |
| 23 | 450 | 0.1% |
| 8 | 450 | 0.1% |
| 4 | 448 | 0.1% |
| 10 | 447 | 0.1% |
| 12 | 446 | 0.1% |
| 6 | 445 | 0.1% |
| 5 | 444 | 0.1% |
| Other values (10277) | 332549 |
| Value | Count | Frequency (%) |
| 1 | 421 | |
| 2 | 474 | |
| 3 | 493 | |
| 4 | 448 | |
| 5 | 444 | |
| 6 | 445 | |
| 7 | 433 | |
| 8 | 450 | |
| 9 | 363 | |
| 10 | 447 |
| Value | Count | Frequency (%) |
| 370143 | 23 | |
| 365356 | 23 | |
| 348485 | 25 | |
| 344335 | 24 | |
| 341653 | 19 | |
| 339129 | 19 | |
| 323756 | 20 | |
| 315779 | 17 | |
| 310778 | 17 | |
| 298646 | 17 |
AANTAL_PAT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 324 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 669598.78 |
| Minimum | 927 |
|---|---|
| Maximum | 1487636 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 927 |
|---|---|
| 5-th percentile | 33050 |
| Q1 | 254307 |
| median | 762394 |
| Q3 | 1026335 |
| 95-th percentile | 1332343 |
| Maximum | 1487636 |
| Range | 1486709 |
| Interquartile range (IQR) | 772028 |
Descriptive statistics
| Standard deviation | 424421.32 |
|---|---|
| Coefficient of variation (CV) | 0.63384424 |
| Kurtosis | -1.1709504 |
| Mean | 669598.78 |
| Median Absolute Deviation (MAD) | 317739 |
| Skewness | -0.054794597 |
| Sum | 2.2571907 × 1011 |
| Variance | 1.8013346 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 880930 | 5102 | 1.5% |
| 874095 | 4354 | 1.3% |
| 843975 | 4347 | 1.3% |
| 894314 | 4333 | 1.3% |
| 880475 | 4273 | 1.3% |
| 897707 | 4212 | 1.2% |
| 765020 | 4089 | 1.2% |
| 803496 | 4028 | 1.2% |
| 762394 | 3949 | 1.2% |
| 1080827 | 3890 | 1.2% |
| Other values (314) | 294519 |
| Value | Count | Frequency (%) |
| 927 | 52 | < 0.1% |
| 1030 | 168 | < 0.1% |
| 1344 | 56 | < 0.1% |
| 1440 | 77 | < 0.1% |
| 1456 | 438 | |
| 1610 | 130 | < 0.1% |
| 1829 | 138 | < 0.1% |
| 1920 | 131 | < 0.1% |
| 2495 | 173 | 0.1% |
| 2520 | 190 |
| Value | Count | Frequency (%) |
| 1487636 | 2975 | |
| 1450398 | 3048 | |
| 1421714 | 3564 | |
| 1344312 | 3543 | |
| 1340618 | 3441 | |
| 1332343 | 3545 | |
| 1316405 | 3463 | |
| 1282943 | 3576 | |
| 1267128 | 3351 | |
| 1265244 | 1177 | 0.3% |
AANTAL_SUBTRAJECT_PER_SPC
Real number (ℝ)
HIGH CORRELATION
| Distinct | 325 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1088791.5 |
| Minimum | 946 |
|---|---|
| Maximum | 2664625 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 946 |
|---|---|
| 5-th percentile | 39816 |
| Q1 | 368644 |
| median | 1106947 |
| Q3 | 1772014 |
| 95-th percentile | 2548457 |
| Maximum | 2664625 |
| Range | 2663679 |
| Interquartile range (IQR) | 1403370 |
Descriptive statistics
| Standard deviation | 758468.58 |
|---|---|
| Coefficient of variation (CV) | 0.69661512 |
| Kurtosis | -0.8588756 |
| Mean | 1088791.5 |
| Median Absolute Deviation (MAD) | 697808 |
| Skewness | 0.30856052 |
| Sum | 3.6702724 × 1011 |
| Variance | 5.7527459 × 1011 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1211794 | 5102 | 1.5% |
| 1281489 | 4354 | 1.3% |
| 1216251 | 4347 | 1.3% |
| 1315573 | 4333 | 1.3% |
| 1300437 | 4273 | 1.3% |
| 1341835 | 4212 | 1.2% |
| 1155938 | 4089 | 1.2% |
| 1205345 | 4028 | 1.2% |
| 1109997 | 3949 | 1.2% |
| 2548457 | 3890 | 1.2% |
| Other values (315) | 294519 |
| Value | Count | Frequency (%) |
| 946 | 52 | < 0.1% |
| 1031 | 168 | |
| 1378 | 56 | < 0.1% |
| 1440 | 77 | < 0.1% |
| 1468 | 255 | |
| 1800 | 183 | |
| 1861 | 130 | |
| 2097 | 138 | |
| 2195 | 131 | |
| 2534 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 2664625 | 3866 | |
| 2663221 | 3793 | |
| 2619060 | 3789 | |
| 2593887 | 3844 | |
| 2548457 | 3890 | |
| 2480210 | 3851 | |
| 2401042 | 3846 | |
| 2178680 | 3757 | |
| 2062274 | 3811 | |
| 2052299 | 1168 | 0.3% |
GEMIDDELDE_VERKOOPPRIJS
Real number (ℝ)
MISSING
| Distinct | 3590 |
|---|---|
| Distinct (%) | 1.3% |
| Missing | 54659 |
| Missing (%) | 16.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3578.4834 |
| Minimum | 70 |
|---|---|
| Maximum | 287220 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 2.6 MiB |
Quantile statistics
| Minimum | 70 |
|---|---|
| 5-th percentile | 140 |
| Q1 | 470 |
| median | 1240 |
| Q3 | 4155 |
| 95-th percentile | 13620 |
| Maximum | 287220 |
| Range | 287150 |
| Interquartile range (IQR) | 3685 |
Descriptive statistics
| Standard deviation | 6536.2725 |
|---|---|
| Coefficient of variation (CV) | 1.8265482 |
| Kurtosis | 141.73423 |
| Mean | 3578.4834 |
| Median Absolute Deviation (MAD) | 1015 |
| Skewness | 7.1037935 |
| Sum | 1.0106961 × 109 |
| Variance | 42722858 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 160 | 2125 | 0.6% |
| 105 | 1957 | 0.6% |
| 110 | 1791 | 0.5% |
| 185 | 1729 | 0.5% |
| 180 | 1629 | 0.5% |
| 175 | 1457 | 0.4% |
| 300 | 1417 | 0.4% |
| 140 | 1396 | 0.4% |
| 145 | 1387 | 0.4% |
| 120 | 1350 | 0.4% |
| Other values (3580) | 266199 | |
| (Missing) | 54659 | 16.2% |
| Value | Count | Frequency (%) |
| 70 | 226 | 0.1% |
| 75 | 75 | < 0.1% |
| 80 | 362 | 0.1% |
| 85 | 921 | |
| 90 | 668 | 0.2% |
| 95 | 720 | 0.2% |
| 100 | 1013 | |
| 105 | 1957 | |
| 110 | 1791 | |
| 115 | 1109 |
| Value | Count | Frequency (%) |
| 287220 | 8 | |
| 148910 | 3 | < 0.1% |
| 142835 | 4 | |
| 122155 | 4 | |
| 116765 | 3 | < 0.1% |
| 109725 | 7 | |
| 108570 | 7 | |
| 107655 | 4 | |
| 101270 | 8 | |
| 99525 | 5 |
| BEHANDELEND_SPECIALISME_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|
| BEHANDELEND_SPECIALISME_CD | 1.000 | 0.216 | 0.007 | 0.012 | -0.060 | -0.054 | -0.534 | -0.454 | 0.053 |
| ZORGPRODUCT_CD | 0.216 | 1.000 | -0.137 | -0.145 | -0.169 | -0.200 | -0.356 | -0.385 | 0.029 |
| AANTAL_PAT_PER_ZPD | 0.007 | -0.137 | 1.000 | 0.996 | 0.334 | 0.332 | 0.094 | 0.102 | -0.295 |
| AANTAL_SUBTRAJECT_PER_ZPD | 0.012 | -0.145 | 0.996 | 1.000 | 0.331 | 0.333 | 0.097 | 0.109 | -0.297 |
| AANTAL_PAT_PER_DIAG | -0.060 | -0.169 | 0.334 | 0.331 | 1.000 | 0.988 | 0.359 | 0.341 | 0.037 |
| AANTAL_SUBTRAJECT_PER_DIAG | -0.054 | -0.200 | 0.332 | 0.333 | 0.988 | 1.000 | 0.374 | 0.371 | 0.046 |
| AANTAL_PAT_PER_SPC | -0.534 | -0.356 | 0.094 | 0.097 | 0.359 | 0.374 | 1.000 | 0.962 | 0.004 |
| AANTAL_SUBTRAJECT_PER_SPC | -0.454 | -0.385 | 0.102 | 0.109 | 0.341 | 0.371 | 0.962 | 1.000 | 0.001 |
| GEMIDDELDE_VERKOOPPRIJS | 0.053 | 0.029 | -0.295 | -0.297 | 0.037 | 0.046 | 0.004 | 0.001 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 11 | 991900023 | 60 | 61 | 61915 | 80341 | 79304 | 103932 | NaN |
| 1 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 11 | 991900020 | 1110 | 1173 | 61915 | 80341 | 79304 | 103932 | 2260.0 |
| 2 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 13 | 991900026 | 2 | 3 | 721 | 730 | 79304 | 103932 | 115.0 |
| 3 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 11 | 991900003 | 2 | 2 | 61915 | 80341 | 79304 | 103932 | 475.0 |
| 4 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 12 | 991900008 | 2581 | 2655 | 17753 | 22861 | 79304 | 103932 | 460.0 |
| 5 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 13 | 991900022 | 2 | 4 | 721 | 730 | 79304 | 103932 | 825.0 |
| 6 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 12 | 991900018 | 3649 | 4042 | 17753 | 22861 | 79304 | 103932 | 440.0 |
| 7 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 11 | 991900024 | 3801 | 4066 | 61915 | 80341 | 79304 | 103932 | 305.0 |
| 8 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 12 | 991900016 | 10337 | 11747 | 17753 | 22861 | 79304 | 103932 | 1150.0 |
| 9 | 1.0 | 2023-07-07 | 2023-07-01 | 2019-01-01 | 1900 | 13 | 991900025 | 20 | 21 | 721 | 730 | 79304 | 103932 | 290.0 |
| VERSIE | DATUM_BESTAND | PEILDATUM | JAAR | BEHANDELEND_SPECIALISME_CD | TYPERENDE_DIAGNOSE_CD | ZORGPRODUCT_CD | AANTAL_PAT_PER_ZPD | AANTAL_SUBTRAJECT_PER_ZPD | AANTAL_PAT_PER_DIAG | AANTAL_SUBTRAJECT_PER_DIAG | AANTAL_PAT_PER_SPC | AANTAL_SUBTRAJECT_PER_SPC | GEMIDDELDE_VERKOOPPRIJS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 337086 | 1.0 | 2023-07-07 | 2023-07-01 | 2016-01-01 | 307 | M16 | 20108179 | 1 | 1 | 6243 | 11399 | 701356 | 1185662 | NaN |
| 337087 | 1.0 | 2023-07-07 | 2023-07-01 | 2020-01-01 | 313 | 077 | 979002344 | 1 | 1 | 3392 | 4042 | 1047127 | 2619060 | NaN |
| 337088 | 1.0 | 2023-07-07 | 2023-07-01 | 2014-01-01 | 303 | 241 | 199299058 | 1 | 1 | 645 | 731 | 1421714 | 1845619 | 4700.0 |
| 337089 | 1.0 | 2023-07-07 | 2023-07-01 | 2014-01-01 | 303 | 143 | 131999251 | 2 | 2 | 81 | 107 | 1421714 | 1845619 | 1845.0 |
| 337090 | 1.0 | 2023-07-07 | 2023-07-01 | 2014-01-01 | 303 | 316 | 140801003 | 3 | 3 | 1047 | 1176 | 1421714 | 1845619 | 775.0 |
| 337091 | 1.0 | 2023-07-07 | 2023-07-01 | 2020-01-01 | 313 | 954 | 110801007 | 1 | 1 | 233 | 375 | 1047127 | 2619060 | 8305.0 |
| 337092 | 1.0 | 2023-07-07 | 2023-07-01 | 2014-01-01 | 303 | 140 | 131999251 | 1 | 1 | 300 | 331 | 1421714 | 1845619 | 1845.0 |
| 337093 | 1.0 | 2023-07-07 | 2023-07-01 | 2015-01-01 | 362 | 323 | 990062019 | 1 | 1 | 598 | 668 | 70900 | 81597 | 2310.0 |
| 337094 | 1.0 | 2023-07-07 | 2023-07-01 | 2015-01-01 | 362 | 223 | 990062019 | 1 | 1 | 1986 | 2072 | 70900 | 81597 | 2310.0 |
| 337095 | 1.0 | 2023-07-07 | 2023-07-01 | 2014-01-01 | 303 | 216 | 199299059 | 1 | 1 | 5741 | 6197 | 1421714 | 1845619 | 2095.0 |